PowerPivot: Perspectives
A spreadsheet may be used in different departments or even different countries. You can create custom Views, or Perspectives. Perspectives can include any combination of Tables and Fields.
Important! PowerPivot Perspectives must be saved to a SharePoint 2013 server with Excel Services. Perspectives can only be used as a data source when the Excel file is saved to a server. Students who are not connected to a SharePoint 2013 server may not be able to complete all of the steps. That is OK.
1. Try
This: Create a Perspective
The PowerPivot window is still open.
Go to
Advanced ->Perspective.
Click on
Create and Manage.
The Perspectives will open.
There are three Tables in our Data Model.
The Fields are in the first column.
Click on the New Perspective button above the Fields.
The New Perspective will become the second column.
This Perspective is empty: It has no check boxes. It has not been named, yet.
Keep
going...
